COUNT3D

Counts the number of numeric entries in a range of cells in the whole workbook.

COUNT3D is very similar to the COUNT function of Microsoft Excel. The main difference is that COUNT3D considers all worksheets, while the original COUNT function doesn't.

Syntax

COUNT3D(range_input, include_current)

range_input - is the range from which you want to count the numeric entries.

include_current - Optional. Boolean argument , either TRUE or FALSE. Decides whether the current worksheet is included in the function's consideration. TRUE means the current worksheet will be considered, and vice versa.

Remarks

• Cells that contain numbers, dates, or text representations of numbers are counted. Empty cells and cells that contain logical values, text, error values or text that cannot be translated into numbers are ignored.
• If you need to count logical values, text, or error values, use the COUNTA3D function.

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]